package cn.wolfcode.mapper;

import cn.wolfcode.domain.Dept;
import org.apache.ibatis.annotations.*;
import org.springframework.web.bind.annotation.DeleteMapping;

import java.util.List;


public interface DeptMapper {
    @Select("select * from dept")
    List<Dept> list();
    @Delete("delete from dept where id= #{id}")
    void delete(Long id);

    @Insert("""
            insert into dept (name,create_time,update_time)
            values (#{name},#{createTime},#{updateTime})
            """)
    void save(Dept dept);

    @Select("select * from dept where id = #{id}")
    Dept findById(Long id);

    @Update("""
            update dept 
            set name = #{name},
                update_time=#{updateTime} 
            where id=#{id}
            
            """)
    void update(Dept dept);
}
